EDA de Ventas

Brought to you by YData

Dataset statistics

Number of variables	13
Number of observations	16.978.680
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	171.936
Duplicate rows (%)	1.0%
Total size in memory	5.4 GiB
Average record size in memory	343.9 B

Variable types

Numeric	7
Categorical	5
Text	1

Alerts

Dataset has 171936 (1.0%) duplicate rows	Duplicates
`brand` is highly overall correlated with `cat1` and 1 other fields	High correlation
`cat1` is highly overall correlated with `brand` and 1 other fields	High correlation
`cat2` is highly overall correlated with `brand` and 1 other fields	High correlation
`cust_request_qty` is highly overall correlated with `cust_request_tn` and 1 other fields	High correlation
`cust_request_tn` is highly overall correlated with `cust_request_qty` and 1 other fields	High correlation
`product_id` is highly overall correlated with `sku_size`	High correlation
`sku_size` is highly overall correlated with `product_id`	High correlation
`tn` is highly overall correlated with `cust_request_qty` and 1 other fields	High correlation
`plan_precios_cuidados` is highly imbalanced (98.2%)	Imbalance
`cust_request_tn` is highly skewed (γ1 = 95.58229409)	Skewed
`tn` is highly skewed (γ1 = 96.08283194)	Skewed
`periodo` is uniformly distributed	Uniform
`cust_request_qty` has 14646469 (86.3%) zeros	Zeros
`cust_request_tn` has 14646469 (86.3%) zeros	Zeros
`tn` has 14646469 (86.3%) zeros	Zeros
`stock_final` has 10719135 (63.1%) zeros	Zeros

Reproduction

Analysis started	2025-06-03 23:20:12.938511
Analysis finished	2025-06-03 23:34:36.897129
Duration	14 minutes and 23.96 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

customer_id
Real number (ℝ)

Distinct	597
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10303.682

Minimum	10001
Maximum	10637
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.5 MiB

Quantile statistics

Minimum	10001
5-th percentile	10030
Q1	10150
median	10299
Q3	10455
95-th percentile	10590
Maximum	10637
Range	636
Interquartile range (IQR)	305

Descriptive statistics

Standard deviation	178.7095
Coefficient of variation (CV)	0.017344237
Kurtosis	-1.1520989
Mean	10303.682
Median Absolute Deviation (MAD)	153
Skewness	0.073405409
Sum	1.7494292 × 10¹¹
Variance	31937.087
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10001	28440	0.2%
10395	28440	0.2%
10398	28440	0.2%
10399	28440	0.2%
10400	28440	0.2%
10402	28440	0.2%
10404	28440	0.2%
10405	28440	0.2%
10406	28440	0.2%
10407	28440	0.2%
Other values (587)	16694280	98.3%

Value	Count	Frequency (%)
10001	28440	0.2%
10002	28440	0.2%
10003	28440	0.2%
10004	28440	0.2%
10005	28440	0.2%
10006	28440	0.2%
10007	28440	0.2%
10008	28440	0.2%
10009	28440	0.2%
10010	28440	0.2%

Value	Count	Frequency (%)
10637	28440	0.2%
10636	28440	0.2%
10635	28440	0.2%
10634	28440	0.2%
10633	28440	0.2%
10632	28440	0.2%
10631	28440	0.2%
10630	28440	0.2%
10629	28440	0.2%
10626	28440	0.2%

product_id
Real number (ℝ)

High correlation

Distinct	780
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20536.509

Minimum	20001
Maximum	21276
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.5 MiB

Quantile statistics

Minimum	20001
5-th percentile	20037
Q1	20233
median	20504
Q3	20815
95-th percentile	21167
Maximum	21276
Range	1275
Interquartile range (IQR)	582

Descriptive statistics

Standard deviation	354.77362
Coefficient of variation (CV)	0.017275264
Kurtosis	-1.0199484
Mean	20536.509
Median Absolute Deviation (MAD)	285
Skewness	0.30801862
Sum	3.4868281 × 10¹¹
Variance	125864.32
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20278	42984	0.3%
20192	42984	0.3%
20020	42984	0.3%
20021	42984	0.3%
20022	42984	0.3%
20010	42984	0.3%
20100	42984	0.3%
20230	42984	0.3%
20623	42984	0.3%
20037	42984	0.3%
Other values (770)	16548840	97.5%

Value	Count	Frequency (%)
20001	21492	0.1%
20002	21492	0.1%
20003	21492	0.1%
20004	21492	0.1%
20005	21492	0.1%
20006	21492	0.1%
20007	21492	0.1%
20008	21492	0.1%
20009	21492	0.1%
20010	42984	0.3%

Value	Count	Frequency (%)
21276	21492	0.1%
21267	21492	0.1%
21266	21492	0.1%
21265	21492	0.1%
21263	21492	0.1%
21262	21492	0.1%
21259	21492	0.1%
21256	21492	0.1%
21252	21492	0.1%
21248	21492	0.1%

periodo
Categorical

Uniform

Distinct	36
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	955.3 MiB

2017-01-01	471630
2017-02-01	471630
2017-09-01	471630
2017-03-01	471630
2017-04-01	471630
Other values (31)	14620530

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	169.786.800
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017-01-01
2nd row	2017-02-01
3rd row	2017-03-01
4th row	2017-04-01
5th row	2017-05-01

Common Values

Value	Count	Frequency (%)
2017-01-01	471630	2.8%
2017-02-01	471630	2.8%
2017-09-01	471630	2.8%
2017-03-01	471630	2.8%
2017-04-01	471630	2.8%
2017-05-01	471630	2.8%
2017-06-01	471630	2.8%
2017-07-01	471630	2.8%
2017-08-01	471630	2.8%
2017-10-01	471630	2.8%
Other values (26)	12262380	72.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-01-01	471630	2.8%
2017-02-01	471630	2.8%
2019-03-01	471630	2.8%
2018-09-01	471630	2.8%
2018-10-01	471630	2.8%
2018-11-01	471630	2.8%
2018-12-01	471630	2.8%
2019-01-01	471630	2.8%
2019-02-01	471630	2.8%
2019-04-01	471630	2.8%
Other values (26)	12262380	72.2%

Most occurring characters

Value	Count	Frequency (%)
0	48106260	28.3%
1	41031810	24.2%
-	33957360	20.0%
2	19808460	11.7%
7	7074450	4.2%
9	7074450	4.2%
8	7074450	4.2%
3	1414890	0.8%
4	1414890	0.8%
5	1414890	0.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	135829440	80.0%
Dash Punctuation	33957360	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	48106260	35.4%
1	41031810	30.2%
2	19808460	14.6%
7	7074450	5.2%
9	7074450	5.2%
8	7074450	5.2%
3	1414890	1.0%
4	1414890	1.0%
5	1414890	1.0%
6	1414890	1.0%

Dash Punctuation

Value	Count	Frequency (%)
-	33957360	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	169786800	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	48106260	28.3%
1	41031810	24.2%
-	33957360	20.0%
2	19808460	11.7%
7	7074450	4.2%
9	7074450	4.2%
8	7074450	4.2%
3	1414890	0.8%
4	1414890	0.8%
5	1414890	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	169786800	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	48106260	28.3%
1	41031810	24.2%
-	33957360	20.0%
2	19808460	11.7%
7	7074450	4.2%
9	7074450	4.2%
8	7074450	4.2%
3	1414890	0.8%
4	1414890	0.8%
5	1414890	0.8%

plan_precios_cuidados
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	842.0 MiB

0.0	16950750
1.0	27930

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	50.936.040
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	16950750	99.8%
1.0	27930	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	16950750	99.8%
1.0	27930	0.2%

Most occurring characters

Value	Count	Frequency (%)
0	33929430	66.6%
.	16978680	33.3%
1	27930	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	33957360	66.7%
Other Punctuation	16978680	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	33929430	99.9%
1	27930	0.1%

Other Punctuation

Value	Count	Frequency (%)
.	16978680	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	50936040	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	33929430	66.6%
.	16978680	33.3%
1	27930	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	50936040	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	33929430	66.6%
.	16978680	33.3%
1	27930	0.1%

cust_request_qty
Real number (ℝ)

High correlation Zeros

Distinct	85
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.29828544

Minimum	0
Maximum	92
Zeros	14646469
Zeros (%)	86.3%
Negative	0
Negative (%)	0.0%
Memory size	129.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	92
Range	92
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.5508814
Coefficient of variation (CV)	5.1993198
Kurtosis	302.13614
Mean	0.29828544
Median Absolute Deviation (MAD)	0
Skewness	14.486984
Sum	5064493
Variance	2.4052331
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	14646469	86.3%
1	1607873	9.5%
2	355885	2.1%
3	119199	0.7%
4	64614	0.4%
5	36682	0.2%
6	24818	0.1%
7	18335	0.1%
8	14547	0.1%
9	11091	0.1%
Other values (75)	79167	0.5%

Value	Count	Frequency (%)
0	14646469	86.3%
1	1607873	9.5%
2	355885	2.1%
3	119199	0.7%
4	64614	0.4%
5	36682	0.2%
6	24818	0.1%
7	18335	0.1%
8	14547	0.1%
9	11091	0.1%

Value	Count	Frequency (%)
92	1	< 0.1%
90	1	< 0.1%
88	1	< 0.1%
85	2	< 0.1%
84	1	< 0.1%
83	1	< 0.1%
79	1	< 0.1%
78	1	< 0.1%
77	1	< 0.1%
76	1	< 0.1%

cust_request_tn
Real number (ℝ)

High correlation Skewed Zeros

Distinct	92002
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.071656524

Minimum	0
Maximum	551.56137
Zeros	14646469
Zeros (%)	86.3%
Negative	0
Negative (%)	0.0%
Memory size	129.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.086
Maximum	551.56137
Range	551.56137
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.3397632
Coefficient of variation (CV)	18.697016
Kurtosis	17552.36
Mean	0.071656524
Median Absolute Deviation (MAD)	0
Skewness	95.582294
Sum	1216633.2
Variance	1.7949654
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	14646469	86.3%
0.01638	14120	0.1%
0.00218	12909	0.1%
0.00983	11954	0.1%
0.01092	10709	0.1%
0.00546	10651	0.1%
0.04095	10583	0.1%
0.03276	10390	0.1%
0.00109	10240	0.1%
0.00491	10189	0.1%
Other values (91992)	2230466	13.1%

Value	Count	Frequency (%)
0	14646469	86.3%
0.0001	170	< 0.1%
0.00013	79	< 0.1%
0.00018	159	< 0.1%
0.0002	238	< 0.1%
0.00021	628	< 0.1%
0.00023	744	< 0.1%
0.00025	299	< 0.1%
0.00026	217	< 0.1%
0.00029	137	< 0.1%

Value	Count	Frequency (%)
551.56137	1	< 0.1%
510.65893	1	< 0.1%
444.41192	1	< 0.1%
439.90647	1	< 0.1%
437.37767	1	< 0.1%
416.64823	1	< 0.1%
407.02225	1	< 0.1%
393.26092	1	< 0.1%
389.02653	1	< 0.1%
384.82574	1	< 0.1%

tn
Real number (ℝ)

High correlation Skewed Zeros

Distinct	91943
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.070047949

Minimum	0
Maximum	547.87849
Zeros	14646469
Zeros (%)	86.3%
Negative	0
Negative (%)	0.0%
Memory size	129.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.0859
Maximum	547.87849
Range	547.87849
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.2914311
Coefficient of variation (CV)	18.436387
Kurtosis	17961.662
Mean	0.070047949
Median Absolute Deviation (MAD)	0
Skewness	96.082832
Sum	1189321.7
Variance	1.6677942
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	14646469	86.3%
0.01638	14125	0.1%
0.00218	12908	0.1%
0.00983	11954	0.1%
0.01092	10714	0.1%
0.00546	10653	0.1%
0.04095	10583	0.1%
0.03276	10404	0.1%
0.00109	10242	0.1%
0.00491	10188	0.1%
Other values (91933)	2230440	13.1%

Value	Count	Frequency (%)
0	14646469	86.3%
0.0001	170	< 0.1%
0.00013	79	< 0.1%
0.00018	159	< 0.1%
0.0002	238	< 0.1%
0.00021	628	< 0.1%
0.00023	746	< 0.1%
0.00025	299	< 0.1%
0.00026	217	< 0.1%
0.00029	137	< 0.1%

Value	Count	Frequency (%)
547.87849	1	< 0.1%
469.45761	1	< 0.1%
439.90647	1	< 0.1%
437.37767	1	< 0.1%
430.90803	1	< 0.1%
414.05146	1	< 0.1%
389.02653	1	< 0.1%
386.60688	1	< 0.1%
384.82574	1	< 0.1%
379.4427	1	< 0.1%

stock_final
Real number (ℝ)

Zeros

Distinct	10047
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.3507683

Minimum	-13.66656
Maximum	1562.0245
Zeros	10719135
Zeros (%)	63.1%
Negative	159399
Negative (%)	0.9%
Memory size	129.5 MiB

Quantile statistics

Minimum	-13.66656
5-th percentile	0
Q1	0
median	0
Q3	2.828945
95-th percentile	38.085946
Maximum	1562.0245
Range	1575.691
Interquartile range (IQR)	2.828945

Descriptive statistics

Standard deviation	39.37932
Coefficient of variation (CV)	4.7156523
Kurtosis	373.86696
Mean	8.3507683
Median Absolute Deviation (MAD)	0
Skewness	15.862276
Sum	1.4178502 × 10⁸
Variance	1550.7309
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10719135	63.1%
0.00109	2388	< 0.1%
-0.01747	2388	< 0.1%
0.04423	2388	< 0.1%
36.58637	2388	< 0.1%
3.42342	2388	< 0.1%
0.0819	2388	< 0.1%
0.7204	2388	< 0.1%
0.049	2388	< 0.1%
0.02092	2388	< 0.1%
Other values (10037)	6238053	36.7%

Value	Count	Frequency (%)
-13.66656	597	< 0.1%
-13.33127	597	< 0.1%
-8.19961	597	< 0.1%
-8.15986	597	< 0.1%
-7.7212	597	< 0.1%
-5.86579	597	< 0.1%
-5.28091	597	< 0.1%
-5.0992	597	< 0.1%
-4.87775	597	< 0.1%
-4.44673	597	< 0.1%

Value	Count	Frequency (%)
1562.02448	597	< 0.1%
1284.38214	597	< 0.1%
1212.36734	597	< 0.1%
1146.09799	597	< 0.1%
1097.55623	597	< 0.1%
1057.38804	597	< 0.1%
1037.85386	597	< 0.1%
1031.01561	597	< 0.1%
978.16446	597	< 0.1%
916.3419	597	< 0.1%

cat1
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	835.0 MiB

PC	9585432
HC	4104972
FOODS	3159324
REF	128952

Length

Max length	5
Median length	2
Mean length	2.5658228
Min length	2

Characters and Unicode

Total characters	43.564.284
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HC
2nd row	HC
3rd row	HC
4th row	HC
5th row	HC

Common Values

Value	Count	Frequency (%)
PC	9585432	56.5%
HC	4104972	24.2%
FOODS	3159324	18.6%
REF	128952	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pc	9585432	56.5%
hc	4104972	24.2%
foods	3159324	18.6%
ref	128952	0.8%

Most occurring characters

Value	Count	Frequency (%)
C	13690404	31.4%
P	9585432	22.0%
O	6318648	14.5%
H	4104972	9.4%
F	3288276	7.5%
D	3159324	7.3%
S	3159324	7.3%
R	128952	0.3%
E	128952	0.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	43564284	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	13690404	31.4%
P	9585432	22.0%
O	6318648	14.5%
H	4104972	9.4%
F	3288276	7.5%
D	3159324	7.3%
S	3159324	7.3%
R	128952	0.3%
E	128952	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	43564284	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	13690404	31.4%
P	9585432	22.0%
O	6318648	14.5%
H	4104972	9.4%
F	3288276	7.5%
D	3159324	7.3%
S	3159324	7.3%
R	128952	0.3%
E	128952	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43564284	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	13690404	31.4%
P	9585432	22.0%
O	6318648	14.5%
H	4104972	9.4%
F	3288276	7.5%
D	3159324	7.3%
S	3159324	7.3%
R	128952	0.3%
E	128952	0.3%

cat2
Categorical

High correlation

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	916.0 MiB

CABELLO	4405860
DEOS	2643516
SOPAS Y CALDOS	1891296
HOGAR	1353996
ROPA LAVADO	1225044
Other values (10)	5458968

Length

Max length	19
Median length	14
Mean length	7.5708861
Min length	2

Characters and Unicode

Total characters	128.543.652
Distinct characters	24
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ROPA LAVADO
2nd row	ROPA LAVADO
3rd row	ROPA LAVADO
4th row	ROPA LAVADO
5th row	ROPA LAVADO

Common Values

Value	Count	Frequency (%)
CABELLO	4405860	25.9%
DEOS	2643516	15.6%
SOPAS Y CALDOS	1891296	11.1%
HOGAR	1353996	8.0%
ROPA LAVADO	1225044	7.2%
PIEL2	1225044	7.2%
ADEREZOS	1074600	6.3%
PIEL1	1010124	5.9%
VAJILLA	709236	4.2%
ROPA ACONDICIONADOR	451332	2.7%
Other values (5)	988632	5.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
cabello	4405860	19.6%
deos	2643516	11.8%
sopas	1891296	8.4%
y	1891296	8.4%
caldos	1891296	8.4%
ropa	1719360	7.6%
hogar	1353996	6.0%
lavado	1225044	5.4%
piel2	1225044	5.4%
aderezos	1074600	4.8%
Other values (8)	3159324	14.1%

Most occurring characters

Value	Count	Frequency (%)
O	18590580	14.5%
A	17816868	13.9%
L	16204968	12.6%
E	12185964	9.5%
S	9950796	7.7%
D	8038008	6.3%
C	7242804	5.6%
P	6168204	4.8%
	5501952	4.3%
R	5115096	4.0%
Other values (14)	21728412	16.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	120806532	94.0%
Space Separator	5501952	4.3%
Decimal Number	2235168	1.7%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	18590580	15.4%
A	17816868	14.7%
L	16204968	13.4%
E	12185964	10.1%
S	9950796	8.2%
D	8038008	6.7%
C	7242804	6.0%
P	6168204	5.1%
R	5115096	4.2%
B	4405860	3.6%
Other values (11)	15087384	12.5%

Decimal Number

Value	Count	Frequency (%)
2	1225044	54.8%
1	1010124	45.2%

Space Separator

Value	Count	Frequency (%)
	5501952	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	120806532	94.0%
Common	7737120	6.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	18590580	15.4%
A	17816868	14.7%
L	16204968	13.4%
E	12185964	10.1%
S	9950796	8.2%
D	8038008	6.7%
C	7242804	6.0%
P	6168204	5.1%
R	5115096	4.2%
B	4405860	3.6%
Other values (11)	15087384	12.5%

Common

Value	Count	Frequency (%)
	5501952	71.1%
2	1225044	15.8%
1	1010124	13.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	128543652	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	18590580	14.5%
A	17816868	13.9%
L	16204968	12.6%
E	12185964	9.5%
S	9950796	7.7%
D	8038008	6.3%
C	7242804	5.6%
P	6168204	4.8%
	5501952	4.3%
R	5115096	4.0%
Other values (14)	21728412	16.9%

cat3
Text

Distinct	84
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	930.3 MiB

Length

Max length	19
Median length	16
Mean length	7.9481013
Min length	3

Characters and Unicode

Total characters	134.948.268
Distinct characters	51
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Liquido
2nd row	Liquido
3rd row	Liquido
4th row	Liquido
5th row	Liquido

Value	Count	Frequency (%)
shampoo	1998756	10.0%
aero	1676376	8.4%
acondicionador	1654884	8.3%
jabon	816696	4.1%
liquido	730728	3.6%
sopas	687744	3.4%
polvo	623268	3.1%
mayonesa	558792	2.8%
noaero	494316	2.5%
gel	472824	2.4%
Other values (80)	10316160	51.5%

Most occurring characters

Value	Count	Frequency (%)
o	11820600	8.8%
O	10187208	7.5%
a	9628416	7.1%
A	9370512	6.9%
e	6769980	5.0%
C	6189696	4.6%
r	5931792	4.4%
S	4577796	3.4%
i	4470336	3.3%
I	4448844	3.3%
Other values (41)	61553088	45.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	68473512	50.7%
Uppercase Letter	63422892	47.0%
Space Separator	3051864	2.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	11820600	17.3%
a	9628416	14.1%
e	6769980	9.9%
r	5931792	8.7%
i	4470336	6.5%
l	4384368	6.4%
s	3825576	5.6%
n	3782592	5.5%
u	2557548	3.7%
d	2428596	3.5%
Other values (15)	12873708	18.8%

Uppercase Letter

Value	Count	Frequency (%)
O	10187208	16.1%
A	9370512	14.8%
C	6189696	9.8%
S	4577796	7.2%
I	4448844	7.0%
N	4233924	6.7%
D	3976020	6.3%
P	3589164	5.7%
M	3567672	5.6%
R	2879928	4.5%
Other values (15)	10402128	16.4%

Space Separator

Value	Count	Frequency (%)
	3051864	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	131896404	97.7%
Common	3051864	2.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	11820600	9.0%
O	10187208	7.7%
a	9628416	7.3%
A	9370512	7.1%
e	6769980	5.1%
C	6189696	4.7%
r	5931792	4.5%
S	4577796	3.5%
i	4470336	3.4%
I	4448844	3.4%
Other values (40)	58501224	44.4%

Common

Value	Count	Frequency (%)
	3051864	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	134561412	99.7%
None	386856	0.3%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	11820600	8.8%
O	10187208	7.6%
a	9628416	7.2%
A	9370512	7.0%
e	6769980	5.0%
C	6189696	4.6%
r	5931792	4.4%
S	4577796	3.4%
i	4470336	3.3%
I	4448844	3.3%
Other values (40)	61166232	45.5%

None

Value	Count	Frequency (%)
ñ	386856	100.0%

brand
Categorical

High correlation

Distinct	35
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	895.6 MiB

NIVEA	2342628
SHAMPOO3	1805328
MAGGI	1740852
DEOS1	1676376
MUSCULO	1396980
Other values (30)	8016516

Length

Max length	9
Median length	8
Mean length	6.3088608
Min length	3

Characters and Unicode

Total characters	107.116.128
Distinct characters	35
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ARIEL
2nd row	ARIEL
3rd row	ARIEL
4th row	ARIEL
5th row	ARIEL

Common Values

Value	Count	Frequency (%)
NIVEA	2342628	13.8%
SHAMPOO3	1805328	10.6%
MAGGI	1740852	10.3%
DEOS1	1676376	9.9%
MUSCULO	1396980	8.2%
LIMPIEX	1053108	6.2%
LANCOME	644760	3.8%
SHAMPOO2	623268	3.7%
NATURA	601776	3.5%
SHAMPOO1	580284	3.4%
Other values (25)	4513320	26.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nivea	2342628	13.8%
shampoo3	1805328	10.6%
maggi	1740852	10.3%
deos1	1676376	9.9%
musculo	1396980	8.2%
limpiex	1053108	6.2%
lancome	644760	3.8%
shampoo2	623268	3.7%
natura	601776	3.5%
shampoo1	580284	3.4%
Other values (25)	4513320	26.6%

Most occurring characters

Value	Count	Frequency (%)
O	12207456	11.4%
A	12164472	11.4%
M	8682768	8.1%
I	8532324	8.0%
E	8209944	7.7%
S	7629660	7.1%
N	4921668	4.6%
P	4835700	4.5%
L	4577796	4.3%
G	4190940	3.9%
Other values (25)	31163400	29.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	100195704	93.5%
Decimal Number	6060744	5.7%
Lowercase Letter	859680	0.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	12207456	12.2%
A	12164472	12.1%
M	8682768	8.7%
I	8532324	8.5%
E	8209944	8.2%
S	7629660	7.6%
N	4921668	4.9%
P	4835700	4.8%
L	4577796	4.6%
G	4190940	4.2%
Other values (15)	24242976	24.2%

Lowercase Letter

Value	Count	Frequency (%)
o	214920	25.0%
m	107460	12.5%
p	107460	12.5%
r	107460	12.5%
t	107460	12.5%
a	107460	12.5%
d	107460	12.5%

Decimal Number

Value	Count	Frequency (%)
1	2944404	48.6%
3	2127708	35.1%
2	988632	16.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	101055384	94.3%
Common	6060744	5.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	12207456	12.1%
A	12164472	12.0%
M	8682768	8.6%
I	8532324	8.4%
E	8209944	8.1%
S	7629660	7.5%
N	4921668	4.9%
P	4835700	4.8%
L	4577796	4.5%
G	4190940	4.1%
Other values (22)	25102656	24.8%

Common

Value	Count	Frequency (%)
1	2944404	48.6%
3	2127708	35.1%
2	988632	16.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	107116128	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	12207456	11.4%
A	12164472	11.4%
M	8682768	8.1%
I	8532324	8.0%
E	8209944	7.7%
S	7629660	7.1%
N	4921668	4.6%
P	4835700	4.5%
L	4577796	4.3%
G	4190940	3.9%
Other values (25)	31163400	29.1%

sku_size
Real number (ℝ)

High correlation

Distinct	67
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	459.64937

Minimum	1
Maximum	10000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.5 MiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	90
median	220
Q3	450
95-th percentile	1000
Maximum	10000
Range	9999
Interquartile range (IQR)	360

Descriptive statistics

Standard deviation	895.1031
Coefficient of variation (CV)	1.9473607
Kurtosis	40.891263
Mean	459.64937
Median Absolute Deviation (MAD)	170
Skewness	5.5270969
Sum	7.8042395 × 10⁹
Variance	801209.55
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	1289520	7.6%
400	1203552	7.1%
50	1031616	6.1%
90	988632	5.8%
350	795204	4.7%
10	687744	4.1%
750	666252	3.9%
500	601776	3.5%
100	601776	3.5%
250	537300	3.2%
Other values (57)	8575308	50.5%

Value	Count	Frequency (%)
1	171936	1.0%
2	214920	1.3%
3	21492	0.1%
4	171936	1.0%
5	322380	1.9%
6	85968	0.5%
8	128952	0.8%
10	687744	4.1%
12	171936	1.0%
15	150444	0.9%

Value	Count	Frequency (%)
10000	42984	0.3%
5000	236412	1.4%
4000	21492	0.1%
3000	429840	2.5%
2000	42984	0.3%
1400	42984	0.3%
1250	21492	0.1%
1000	279396	1.6%
950	64476	0.4%
930	300888	1.8%

	brand	cat1	cat2	cust_request_qty	cust_request_tn	customer_id	periodo	plan_precios_cuidados	product_id	sku_size	stock_final	tn
brand	1.000	0.999	0.825	0.008	0.008	0.000	0.000	0.081	0.374	0.272	0.073	0.008
cat1	0.999	1.000	1.000	0.007	0.008	0.000	0.000	0.015	0.312	0.233	0.064	0.007
cat2	0.825	1.000	1.000	0.007	0.007	0.000	0.000	0.051	0.284	0.454	0.063	0.007
cust_request_qty	0.008	0.007	0.007	1.000	0.996	-0.302	0.005	0.021	-0.170	0.007	0.038	0.996
cust_request_tn	0.008	0.008	0.007	0.996	1.000	-0.306	0.001	0.001	-0.187	0.021	0.040	1.000
customer_id	0.000	0.000	0.000	-0.302	-0.306	1.000	0.000	0.031	0.000	0.000	-0.000	-0.306
periodo	0.000	0.000	0.000	0.005	0.001	0.000	1.000	0.021	0.000	0.000	0.050	0.001
plan_precios_cuidados	0.081	0.015	0.051	0.021	0.001	0.031	0.021	1.000	0.033	0.007	0.002	0.001
product_id	0.374	0.312	0.284	-0.170	-0.187	0.000	0.000	0.033	1.000	-0.518	-0.120	-0.187
sku_size	0.272	0.233	0.454	0.007	0.021	0.000	0.000	0.007	-0.518	1.000	0.067	0.021
stock_final	0.073	0.064	0.063	0.038	0.040	-0.000	0.050	0.002	-0.120	0.067	1.000	0.040
tn	0.008	0.007	0.007	0.996	1.000	-0.306	0.001	0.001	-0.187	0.021	0.040	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	customer_id	product_id	periodo	cust_request_qty	cust_request_tn	tn	cat1	cat2	cat3	brand	sku_size
0	10001	20001	2017-01-01	11.0	99.43861	99.43861	HC	ROPA LAVADO	Liquido	ARIEL	3000
1	10001	20001	2017-02-01	23.0	198.84365	198.84365	HC	ROPA LAVADO	Liquido	ARIEL	3000
2	10001	20001	2017-03-01	33.0	92.46537	92.46537	HC	ROPA LAVADO	Liquido	ARIEL	3000
3	10001	20001	2017-04-01	8.0	13.29728	13.29728	HC	ROPA LAVADO	Liquido	ARIEL	3000
4	10001	20001	2017-05-01	15.0	101.20711	101.00563	HC	ROPA LAVADO	Liquido	ARIEL	3000
5	10001	20001	2017-06-01	25.0	128.04792	128.04792	HC	ROPA LAVADO	Liquido	ARIEL	3000
6	10001	20001	2017-07-01	18.0	101.20711	101.20711	HC	ROPA LAVADO	Liquido	ARIEL	3000
7	10001	20001	2017-08-01	17.0	43.33930	43.33930	HC	ROPA LAVADO	Liquido	ARIEL	3000
8	10001	20001	2017-09-01	36.0	289.35024	289.35024	HC	ROPA LAVADO	Liquido	ARIEL	3000
9	10001	20001	2017-10-01	22.0	222.11389	222.11389	HC	ROPA LAVADO	Liquido	ARIEL	3000

	customer_id	product_id	periodo	stock_final	cat1	cat2	cat3	brand	sku_size
16978670	10637	21276	2019-03-01	1.68932	PC	PIEL1	Cara	NIVEA	140
16978671	10637	21276	2019-04-01	1.57051	PC	PIEL1	Cara	NIVEA	140
16978672	10637	21276	2019-05-01	1.30988	PC	PIEL1	Cara	NIVEA	140
16978673	10637	21276	2019-06-01	1.29354	PC	PIEL1	Cara	NIVEA	140
16978674	10637	21276	2019-07-01	1.28908	PC	PIEL1	Cara	NIVEA	140
16978675	10637	21276	2019-08-01	1.08488	PC	PIEL1	Cara	NIVEA	140
16978676	10637	21276	2019-09-01	0.87622	PC	PIEL1	Cara	NIVEA	140
16978677	10637	21276	2019-10-01	1.05889	PC	PIEL1	Cara	NIVEA	140
16978678	10637	21276	2019-11-01	1.06112	PC	PIEL1	Cara	NIVEA	140
16978679	10637	21276	2019-12-01	1.05592	PC	PIEL1	Cara	NIVEA	140

Most frequently occurring

	customer_id	product_id	periodo	cust_request_qty	cust_request_tn	tn	cat1	cat2	cat3	brand	sku_size	# duplicates
0	10001	20010	2017-01-01	3.0	1.31914	1.31914	HC	ROPA LAVADO	Polvo	LIMPIEX	400	2
1	10001	20010	2017-02-01	1.0	0.11357	0.11357	HC	ROPA LAVADO	Polvo	LIMPIEX	400	2
2	10001	20010	2017-03-01	0.0	0.00000	0.00000	HC	ROPA LAVADO	Polvo	LIMPIEX	400	2
3	10001	20010	2017-04-01	0.0	0.00000	0.00000	HC	ROPA LAVADO	Polvo	LIMPIEX	400	2
4	10001	20010	2017-05-01	0.0	0.00000	0.00000	HC	ROPA LAVADO	Polvo	LIMPIEX	400	2
5	10001	20010	2017-06-01	0.0	0.00000	0.00000	HC	ROPA LAVADO	Polvo	LIMPIEX	400	2
6	10001	20010	2017-07-01	0.0	0.00000	0.00000	HC	ROPA LAVADO	Polvo	LIMPIEX	400	2
7	10001	20010	2017-08-01	0.0	0.00000	0.00000	HC	ROPA LAVADO	Polvo	LIMPIEX	400	2
8	10001	20010	2017-09-01	0.0	0.00000	0.00000	HC	ROPA LAVADO	Polvo	LIMPIEX	400	2
9	10001	20010	2017-10-01	0.0	0.00000	0.00000	HC	ROPA LAVADO	Polvo	LIMPIEX	400	2

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Most occurring scripts